package com.jsyl.lwbk.business.service.impl;

import com.baomidou.mybatisplus.core.toolkit.IdWorker;
import com.jsyl.lwbk.business.mapper.ChildMapper;
import com.jsyl.lwbk.business.mapper.ChildProjectConfigMapper;
import com.jsyl.lwbk.business.constant.ProjectCodeConstant;
import com.jsyl.lwbk.business.domain.Child;
import com.jsyl.lwbk.business.domain.Integration;
import com.jsyl.lwbk.business.mapper.IntegrationMapper;
import com.jsyl.lwbk.common.utils.AgeUtils;
import org.apache.commons.collections.CollectionUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

/**
 * 项目初始化逻辑
 *
 * @author Fitch
 * 2022/3/8
 */
@Service
public class InitRule {
    @Autowired
    ChildMapper childMapper;
    @Autowired
    ChildProjectConfigMapper childProjectConfigMapper;
    @Autowired
    IntegrationMapper integrationMapper;

    /**
     * 小孩第一次初始化项目
     *
     * @param childId
     */
    public void initConfig(Long childId) {
        Child child = childMapper.selectById(childId);
        //1、获取按年龄初始化项目
        int age = AgeUtils.computationsAge(child.getBirthYear(), child.getBirthMonth());
        List<Integration> integrationList = this.integrationMapper.selectByAge(age);
        //2、获取按年级初始化项目
        //  ＜一年级（学前的学员）（1）首次解锁【双手拍球】【原地拍球】【定点拍球】
        //  一年级≤学员≤二年级（1）首次就解锁【双手拍球】【原地拍球】【定点拍球】
        List<String> projectCodeList = new ArrayList<>();
        if(child.getGrade() !=null && child.getGrade()<1){
            projectCodeList.add(ProjectCodeConstant.拍球_双手拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_原地拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_定点拍球);
        }
        if(child.getGrade() !=null && child.getGrade()>=1 && child.getGrade()<=2){
            projectCodeList.add(ProjectCodeConstant.拍球_双手拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_原地拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_定点拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_交替拍球);
        }

        if(child.getGrade() !=null && child.getGrade()>=3){
            projectCodeList.add(ProjectCodeConstant.拍球_双手拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_原地拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_定点拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_交替拍球);
            projectCodeList.add(ProjectCodeConstant.拍球_拍跨球);
        }
        if(CollectionUtils.isNotEmpty(projectCodeList)){
            List<Integration> integrationList1 = this.integrationMapper.findListByCode(projectCodeList);
            integrationList.addAll(integrationList1);
        }
        //3、数据处理
        StringBuffer sql = new StringBuffer();
        int i = 1;
        for (Integration integration : integrationList) {
            if (i == integrationList.size()) {
                sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"" + integration.getCode() + "\",\"" + integration.getName() + "\",1,0,\"systemInit\",now())");
            } else {
                sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"" + integration.getCode() + "\",\"" + integration.getName() + "\",1,0,\"systemInit\",now()),");
                i++;
            }
        }
        if (sql != null) {
            this.childProjectConfigMapper.batchInsert(sql.toString());
        }

    }

    private void initTree(Long childId) {
        StringBuffer sql = new StringBuffer();
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080101\",\"学拍球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050301\",\"直线（跳绳）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050702\",\"双脚跳—纵向\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050701\",\"双脚跳—原地\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060201\",\"踢球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060205\",\"串珠子\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070101\",\"双手上抛 \",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070201\",\"双手对抛\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080401\",\"踢球—对传\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080402\",\"踢球—射门\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080403\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090701\",\"两步一格\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090702\",\"正向1122\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090703\",\"侧向1122\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090704\",\"进进出\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090801\",\"栏架（低）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090802\",\"栏架（高）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040201\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040202\",\"钻爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040203\",\"障碍组合\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100501\",\"栏杆等跨越（高）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100502\",\"踏板等跨域（远）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100503\",\"跳箱等翻越\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100504\",\"锥桶等变向\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100801\",\"夹沙包走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100802\",\"夹沙包跑\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S041001\",\"倒爬2米\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S041002\",\"阻力倒爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080901\",\"双手推球竞速\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080902\",\"灵敏圈滚球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080903\",\"外力推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1707\",\"搬砖过河\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1302\",\"绕桩推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1303\",\"举圈钻圈\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0406\",\"虫虫爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0810\",\"背靠背传球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0905\",\"推拉物行走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0909\",\"上下楼梯\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100201\",\"追物跑\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1105\",\"胸部推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S081201\",\"双手颠球（地面）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S081202\",\"颠球（地面）走路\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0910\",\"抱球走路\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040901\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040902\",\"钻爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040903\",\"S型障碍\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050101\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020501\",\"原地踏步走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010201\",\"静站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010204\",\"大字站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010101\",\"静坐\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010103\",\"闭眼静坐\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010106\",\"静坐+坐篮球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1201\",\"侧滚翻\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1001\",\"跑大滑梯\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0803\",\"趴地推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0513\",\"跳袋\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0514\",\"羊角球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0201\",\"排队回家\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020201\",\"绕场走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0203\",\"踏步走路\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0506\",\"原地剪刀跳\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020601\",\"左右手\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020602\",\"摸关节\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020603\",\"向后转\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020604\",\"五官反应\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1113\",\"萝卜蹲\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0601\",\"单脚站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090401\",\"提踵\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090402\",\"脚尖站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S091101\",\"脚尖走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1208\",\"摸墙转\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S140301\",\"乒乓球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150101\",\"触觉刷按摩\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150102\",\"肢体按摩\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150103\",\"软球按摩\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150104\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150201\",\"颗粒大龙球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150202\",\"大龙球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150203\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150301\",\"距离判断\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S051201\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S051202\",\"节奏训练\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120301\",\"晃动\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120302\",\"旋转\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120201\",\"晃动\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120202\",\"横抱筒\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1204\",\"大陀螺\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1401\",\"串珠子\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1404\",\"搭积木\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1402\",\"夹珠子\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060401\",\"原地走直线\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060402\",\"脚跟顶脚尖正走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060403\",\"脚跟顶脚尖倒走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060404\",\"走平衡木\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060405\",\"走1/4圆\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060406\",\"走平衡组合\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060407\",\"走万象组平衡\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060408\",\"走泡沫半轴\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060409\",\"走平衡步道\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060410\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060501\",\"平衡脚踏车正走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040101\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040102\",\"钻爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040103\",\"攀爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0403\",\"猫爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0502\",\"小马跳\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0901\",\"螃蟹走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0504\",\"放学跳\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1705\",\"揪尾巴\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1708\",\"彩虹伞\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1709\",\"一网不捞鱼\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1710\",\"叫号接包砍人\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1711\",\"123木头人\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1712\",\"滚雪球躲闪\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1713\",\"红黄绿灯\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1714\",\"听雨点快慢走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1715\",\"松鼠找家\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1716\",\"过河游戏\",1,0,\"systemInit\",now())");
        this.childProjectConfigMapper.batchInsert(sql.toString());
    }

    private void initFour(Long childId) {
        StringBuffer sql = new StringBuffer();
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080101\",\"学拍球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070501\",\"学动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S111201\",\"学平举\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050301\",\"直线（跳绳）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050702\",\"双脚跳—纵向\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050701\",\"双脚跳—原地\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060201\",\"踢球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060205\",\"串珠子\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060601\",\"站立\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070101\",\"双手上抛 \",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070201\",\"双手对抛\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080401\",\"踢球—对传\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080402\",\"踢球—射门\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080403\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090701\",\"两步一格\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090702\",\"正向1122\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090703\",\"侧向1122\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090704\",\"进进出\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090801\",\"栏架（低）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090802\",\"栏架（高）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040201\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040202\",\"钻爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040203\",\"障碍组合\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070502\",\"网球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070503\",\"小软球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S070504\",\"沙包\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100501\",\"栏杆等跨越（高）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100502\",\"踏板等跨域（远）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100503\",\"跳箱等翻越\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100504\",\"锥桶等变向\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100801\",\"夹沙包走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100802\",\"夹沙包跑\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S041001\",\"倒爬2米\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S041002\",\"阻力倒爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080901\",\"双手推球竞速\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080902\",\"灵敏圈滚球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S080903\",\"外力推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1707\",\"搬砖过河\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1302\",\"绕桩推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1303\",\"举圈钻圈\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0406\",\"虫虫爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0810\",\"背靠背传球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0905\",\"推拉物行走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0909\",\"上下楼梯\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S100201\",\"追物跑\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1105\",\"胸部推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S081201\",\"双手颠球（地面）\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S081202\",\"颠球（地面）走路\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0910\",\"抱球走路\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040901\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040902\",\"钻爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040903\",\"S型障碍\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S050101\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020501\",\"原地踏步走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010201\",\"静站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010204\",\"大字站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010101\",\"静坐\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010103\",\"闭眼静坐\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S010106\",\"静坐+坐篮球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1201\",\"侧滚翻\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1001\",\"跑大滑梯\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0803\",\"趴地推球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0513\",\"跳袋\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0514\",\"羊角球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0201\",\"排队回家\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020201\",\"绕场走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0203\",\"踏步走路\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0506\",\"原地剪刀跳\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020601\",\"左右手\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020602\",\"摸关节\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020603\",\"向后转\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S020604\",\"五官反应\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1113\",\"萝卜蹲\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0601\",\"单脚站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090401\",\"提踵\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S090402\",\"脚尖站\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S091101\",\"脚尖走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1208\",\"摸墙转\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S140301\",\"乒乓球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150101\",\"触觉刷按摩\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150102\",\"肢体按摩\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150103\",\"软球按摩\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150104\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150201\",\"颗粒大龙球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150202\",\"大龙球\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150203\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S150301\",\"距离判断\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S051201\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S051202\",\"节奏训练\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120301\",\"晃动\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120302\",\"旋转\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120201\",\"晃动\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S120202\",\"横抱筒\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1204\",\"大陀螺\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1401\",\"串珠子\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1404\",\"搭积木\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1402\",\"夹珠子\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060401\",\"原地走直线\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060402\",\"脚跟顶脚尖正走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060403\",\"脚跟顶脚尖倒走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060404\",\"走平衡木\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060405\",\"走1/4圆\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060406\",\"走平衡组合\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060407\",\"走万象组平衡\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060408\",\"走泡沫半轴\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060409\",\"走平衡步道\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060410\",\"其他\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S060501\",\"平衡脚踏车正走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040101\",\"基本动作\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040102\",\"钻爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S040103\",\"攀爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0403\",\"猫爬\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0502\",\"小马跳\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0901\",\"螃蟹走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S0504\",\"放学跳\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1705\",\"揪尾巴\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1708\",\"彩虹伞\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1709\",\"一网不捞鱼\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1710\",\"叫号接包砍人\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1711\",\"123木头人\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1712\",\"滚雪球躲闪\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1713\",\"红黄绿灯\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1714\",\"听雨点快慢走\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1715\",\"松鼠找家\",1,0,\"systemInit\",now()),");
        sql.append("(" + IdWorker.getId() + ",\"" + childId + "\",\"S1716\",\"过河游戏\",1,0,\"systemInit\",now())");
        this.childProjectConfigMapper.batchInsert(sql.toString());
    }
}
